IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'spILPData_Update')
	BEGIN
		PRINT 'Dropping Procedure spILPData_Update'
		DROP  Procedure  spILPData_Update
	END

GO

PRINT 'Creating Procedure spILPData_Update'
GO
Create Procedure dbo.spILPData_Update
	( 	  
		@ID int, 
		@AccNo varchar(13), 
		@BondAmt money = null, 
		@OutBal money = null, 
		@AmtPastDue money = null, 
		@ValAmt money = null, 
		@PrePaid money = null, 
		@Monthly money = null, 
		@BondRegDate DateTime = null, 
		@ValDate DateTime = null, 
		@Status char(3) = null, 
		@SubStatus char(3) = null, 
		@BranchCode char(3) = null, 
		@custID varchar(25) = null, 
		@custName1 varchar(100) = null, 
		@custName2 varchar(100) = null, 
		@custPersTel varchar(20) = null, 
		@custBussTel varchar(20) = null, 
		@custContTel varchar(20) = null, 
		@AccountDate DateTime = null, 
		@Suburb varchar(50) = null, 
		@Stand varchar(50) = null, 
		@Complex varchar(50) = null
	)
AS
  /* 
    ------------------------------------------------------------------------------
    - Change History
    - --------------
    - Date          Description
    ------------------------------------------------------------------------------
    - 8/22/2007    Initial version Updated
    ------------------------------------------------------------------------------
  */

	-- Declare the required variables

	-- Update the required new record
	UPDATE ILPData
	SET
		BondAmt = @BondAmt, 
		OutBal = @OutBal, 
		AmtPastDue = @AmtPastDue, 
		ValAmt = @ValAmt, 
		PrePaid = @PrePaid, 
		Monthly = @Monthly, 
		BondRegDate = @BondRegDate, 
		ValDate = @ValDate, 
		Status = @Status, 
		SubStatus = @SubStatus, 
		BranchCode = @BranchCode, 
		custID = @custID, 
		custName1 = @custName1, 
		custName2 = @custName2, 
		custPersTel = @custPersTel, 
		custBussTel = @custBussTel, 
		custContTel = @custContTel, 
		AccountDate = @AccountDate, 
		Suburb = @Suburb, 
		Stand = @Stand, 
		Complex = @Complex		
	WHERE AccNo = @AccNo

	-- Return to calling method
	RETURN
	
GO
